Home-page: http://www.python-excel.org

Python package "xlwt"

Purpose: Provide a library for developers to use to generate spreadsheet files compatible with Microsoft Excel versions 95 to 2003.

Maintainer: John Machin, Lingfo Pty Ltd (sjmachin@lexicon.net)

Licence: BSD-style (see licences.py)

Version of xlwt: 0.7.2

Version of Python required: 2.3 to 2.6

External modules required: None

The package itself is pure Python with no dependencies on modules or packages outside the standard Python distribution.

Quick start:

import xlwt
from datetime import datetime

style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on',
	num_format_str='#,##0.00')
style1 = xlwt.easyxf(num_format_str='D-MMM-YY')

wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')

ws.write(0, 0, 1234.56, style0)
ws.write(1, 0, datetime.now(), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))

wb.save('example.xls')

Installation:

• Any OS: Unzip the .zip file into a suitable directory, chdir to that directory, then do "python setup.py install".
• If PYDIR is your Python installation directory: the main files are in PYDIR/Lib/site-packages/xlwt, docs are in the doc subdirectory.
• If os.sep != "/": make the appropriate adjustments.

Download URLs:

• Packaged: http://pypi.python.org/pypi/xlwt
• SVN: https://secure.simplistix.co.uk/svn/xlwt/trunk

Documentation:

Documentation can be found in the 'doc' directory of the xlwt package. If these aren't sufficient, please consult the code in the examples directory and the source code itself.

Problems:

Try the following in this order:

1. Read the source
2. Ask a question on http://groups.google.com/group/python-excel/
3. E-mail the xlwt maintainer (sjmachin at lexicon.net), including "[xlwt]" as part of the message subject.

Acknowledgements:

• xlwt is a fork of the pyExcelerator package, which was developed by Roman V. Kiseliov. "This product includes software developed by Roman V. Kiseliov <roman@kiseliov.ru>."
• xlwt uses ANTLR v 2.7.7 to generate its formula compiler.
• << a growing list of names; see HISTORY.html >>: feedback, testing, test files, ...